PROVEEDOR

"192.168.0.1:sipop"

PROVEEDOR

Descriptions

PROVEEDORES COMERCIALES Y/O DONANTES DEL SISTEMA

Fields

Name	Data type	Description
ID_PROVEEDOR	CHAR (3)	ID del proveedor
NOMBRE_PROVEEDOR	CHAR (30)	Nombre del proveedor
PAIS	CHAR (3)	Pais de origen del proveedor
DIRECCION	CHAR (30)	Direccion
CONTACTO	CHAR (30)	Nombre del contacto
TELEFONO	CHAR (30)	telefono
CORREO	CHAR (30)	correo electronico

Triggers

There are no triggers for table PROVEEDOR

Indices

There are no indices for table PROVEEDOR

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
PAIS	INTEG_281	PAIS	ID_PAIS	RESTRICT	RESTRICT

Referenced

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
REGISTRODEINGRESO	INTEG_284	PROVEEDOR	ID_PROVEEDOR	RESTRICT	RESTRICT
REGISTRODEINGRESOHQ	INTEG_233	PROVEEDOR	ID_PROVEEDOR	RESTRICT	RESTRICT

Definition


CREATE TABLE PROVEEDOR (
    ID_PROVEEDOR CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    NOMBRE_PROVEEDOR CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    PAIS CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    DIRECCION CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    CONTACTO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    TELEFONO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE,
    CORREO CHAR (30) CHARACTER SET NONE NOT NULL COLLATE NONE);

ALTER TABLE PROVEEDOR ADD PRIMARY KEY (ID_PROVEEDOR);
ALTER TABLE PROVEEDOR ADD  FOREIGN KEY (PAIS) REFERENCES PAIS (ID_PAIS);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.